/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : leisurely

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 28/08/2020 14:49:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for PDMAN_DB_VERSION
-- ----------------------------
DROP TABLE IF EXISTS `PDMAN_DB_VERSION`;
CREATE TABLE "PDMAN_DB_VERSION" (
  "DB_VERSION" varchar(256) DEFAULT NULL,
  "VERSION_DESC" varchar(1024) DEFAULT NULL,
  "CREATED_TIME" varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


-- ----------------------------
-- Table structure for com_label
-- ----------------------------
DROP TABLE IF EXISTS `com_label`;
CREATE TABLE "com_label" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "group_id" varchar(32) NOT NULL COMMENT '标签分组id',
  "name" varchar(255) NOT NULL COMMENT '标签名称',
  "code" varchar(20) NOT NULL COMMENT '标签编码',
  "label_type" tinyint(2) DEFAULT '0' COMMENT '便签类型 0：固定标签 ，1非固定标签',
  "paixu" int(6) NOT NULL DEFAULT '0' COMMENT '排序',
  "description" varchar(256) DEFAULT NULL COMMENT '描述',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='标签';

-- ----------------------------
-- Table structure for com_label_data
-- ----------------------------
DROP TABLE IF EXISTS `com_label_data`;
CREATE TABLE "com_label_data" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "business_id" varchar(100) NOT NULL COMMENT '业务id',
  "business_data_id" varchar(50) NOT NULL COMMENT '业务数据id',
  "label_id" varchar(32) NOT NULL COMMENT '标签id',
  "label_code" varchar(100) DEFAULT NULL COMMENT '标签编码',
  "releve_column" varchar(100) DEFAULT NULL COMMENT '关联列名',
  "description" varchar(256) DEFAULT NULL COMMENT '描述',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='标签数据';

-- ----------------------------
-- Table structure for com_label_group
-- ----------------------------
DROP TABLE IF EXISTS `com_label_group`;
CREATE TABLE "com_label_group" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "name" varchar(255) DEFAULT NULL COMMENT '分组名称',
  "parent_id" varchar(40) DEFAULT '0' COMMENT '父级id',
  "parent_name" varchar(255) DEFAULT NULL COMMENT '父级名称',
  "sub_count" int(2) DEFAULT NULL COMMENT '下级数量',
  "paixu" int(6) NOT NULL DEFAULT '0' COMMENT '排序',
  "description" varchar(256) DEFAULT NULL COMMENT '描述',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='标签分组';

-- ----------------------------
-- Table structure for com_label_slave
-- ----------------------------
DROP TABLE IF EXISTS `com_label_slave`;
CREATE TABLE "com_label_slave" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "label_id" varchar(32) NOT NULL COMMENT '标签id 关联标签',
  "name" varchar(255) NOT NULL COMMENT '标签名称',
  "start" varchar(255) DEFAULT NULL COMMENT '标签开始规则',
  "end" varchar(255) DEFAULT NULL COMMENT '标签结束规则',
  "paixu" int(6) NOT NULL DEFAULT '0' COMMENT '排序',
  "description" varchar(256) DEFAULT NULL COMMENT '描述',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='从属标签（非固定标签）';

-- ----------------------------
-- Table structure for oauth_access_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE "oauth_access_token" (
  "token_id" varchar(256) DEFAULT NULL COMMENT 'MD5加密的access_token的值',
  "token" blob COMMENT 'OAuth2AccessToken.java对象序列化后的二进制数据',
  "authentication_id" varchar(48) NOT NULL COMMENT 'MD5加密过的username,client_id,scope',
  "user_name" varchar(256) DEFAULT NULL COMMENT '登录的用户名',
  "client_id" varchar(256) DEFAULT NULL COMMENT '客户端ID',
  "authentication" blob COMMENT 'OAuth2Authentication.java对象序列化后的二进制数据',
  "refresh_token" varchar(256) DEFAULT NULL COMMENT 'MD5加密果的refresh_token的值',
  PRIMARY KEY ("authentication_id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='访问令牌';

-- ----------------------------
-- Table structure for oauth_approvals
-- ----------------------------
DROP TABLE IF EXISTS `oauth_approvals`;
CREATE TABLE "oauth_approvals" (
  "id" bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  "userId" varchar(256) DEFAULT NULL COMMENT '登录的用户名',
  "clientId" varchar(48) DEFAULT NULL COMMENT '客户端ID',
  "scope" varchar(256) DEFAULT NULL COMMENT '申请的权限',
  "status" varchar(10) DEFAULT NULL COMMENT '状态（Approve或Deny）',
  "expiresAt" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  "lastModifiedAt" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最终修改时间',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='授权记录';

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE "oauth_client_details" (
  "client_id" varchar(48) NOT NULL COMMENT '客户端ID',
  "resource_ids" varchar(2000) DEFAULT NULL COMMENT '资源ID集合,多个资源时用逗号(,)分隔',
  "client_secret" varchar(256) DEFAULT NULL COMMENT '客户端密匙',
  "scope" varchar(256) DEFAULT NULL COMMENT '客户端申请的权限范围',
  "authorized_grant_types" varchar(256) DEFAULT NULL COMMENT '客户端支持的grant_type',
  "web_server_redirect_uri" varchar(256) DEFAULT NULL COMMENT '重定向URI',
  "authorities" varchar(2000) DEFAULT NULL COMMENT '客户端所拥有的Spring Security的权限值，多个用逗号(,)分隔',
  "access_token_validity" int(11) DEFAULT NULL COMMENT '访问令牌有效时间值(单位:秒)',
  "refresh_token_validity" int(11) DEFAULT NULL COMMENT '更新令牌有效时间值(单位:秒)',
  "additional_information" varchar(4096) DEFAULT NULL COMMENT '预留字段',
  "autoapprove" varchar(256) DEFAULT NULL COMMENT '用户是否自动Approval操作',
  PRIMARY KEY ("client_id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='客户端信息';

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` VALUES ('gitlab', '', '$2a$10$gJLg.aDOSrarmTQZpBbOBeskx5dJEtgFAFrUM/719eGd0iM/9rKNK', 'all', 'authorization_code,refresh_token', 'http://192.168.100.38:8089/users/auth/HiRong/callback', 'aaa', 3600, 7200, '{}', '');
INSERT INTO `oauth_client_details` VALUES ('webapp', '', '$2a$10$IOKCUe9HQAQf2/ZFMxqAAOcO0yUcd/7cCMKVZQ4.CW/6paVmQDsoa', 'all', 'authorization_code,refresh_token,password', 'http://www.baidu.com', '', 7200, 1296000, '{}', '');
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE "oauth_client_token" (
  "token_id" varchar(256) DEFAULT NULL COMMENT 'MD5加密的access_token值',
  "token" blob COMMENT 'OAuth2AccessToken.java对象序列化后的二进制数据',
  "authentication_id" varchar(48) NOT NULL COMMENT 'MD5加密过的username,client_id,scope',
  "user_name" varchar(256) DEFAULT NULL COMMENT '登录的用户名',
  "client_id" varchar(256) DEFAULT NULL COMMENT '客户端ID',
  PRIMARY KEY ("authentication_id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='客户端token表';

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE "oauth_code" (
  "code" varchar(256) DEFAULT NULL COMMENT '授权码(未加密)',
  "authentication" blob COMMENT 'AuthorizationRequestHolder.java对象序列化后的二进制数据'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='授权码';

-- ----------------------------
-- Table structure for oauth_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE "oauth_refresh_token" (
  "token_id" varchar(256) DEFAULT NULL COMMENT 'MD5加密过的refresh_token的值',
  "token" blob COMMENT 'OAuth2RefreshToken.java对象序列化后的二进制数据',
  "authentication" blob COMMENT 'OAuth2Authentication.java对象序列化后的二进制数据'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='更新令牌';

-- ----------------------------
-- Table structure for sys_department
-- ----------------------------
DROP TABLE IF EXISTS `sys_department`;
CREATE TABLE "sys_department" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "dep_name" varchar(255) NOT NULL COMMENT '组织名字',
  "dep_code" varchar(40) NOT NULL COMMENT '组织机构代码',
  "parent_id" varchar(40) DEFAULT NULL COMMENT '父级id',
  "parent_name" varchar(255) DEFAULT NULL COMMENT '父级名字',
  "sub_count" int(5) unsigned DEFAULT '0' COMMENT '拥有的子节点数量',
  "top_id" varchar(32) DEFAULT '0' COMMENT '顶级组织id',
  "level" tinyint(3) DEFAULT '1' COMMENT '组织结构级别 默认都是第一级，每往下一级加1',
  "logo" varchar(500) DEFAULT NULL COMMENT '组织的logo',
  "principal" varchar(255) DEFAULT NULL COMMENT '负责人',
  "link_phone" varchar(255) DEFAULT NULL COMMENT '联系电话',
  "province_id" varchar(40) DEFAULT NULL COMMENT '省id',
  "city_id" varchar(40) DEFAULT NULL COMMENT '市id',
  "county_id" varchar(40) DEFAULT NULL COMMENT '县id',
  "county_name" varchar(250) DEFAULT NULL COMMENT '县级以上名字 ，中间用-分割',
  "dep_address" varchar(255) DEFAULT NULL COMMENT '详细地址',
  "description" longtext COMMENT '组织描述',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) DEFAULT '1' COMMENT '状态  1可用 ：0 禁用',
  "paixu" int(4) DEFAULT '0' COMMENT '排序，也可当级别用',
  "remark" varchar(500) DEFAULT NULL COMMENT '备注',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='组织结构';

-- ----------------------------
-- Records of sys_department
-- ----------------------------
BEGIN;
INSERT INTO `sys_department` VALUES ('1280009201233432577', '逍遥域', 'xiaoyaoyu', '0', NULL, 3, '0', 1, NULL, 'safs', 'adsfas', '1231', '2312', '31231', '123131', '1231', '123', NULL, NULL, '2020-07-06 13:22:29', NULL, NULL, '2020-08-18 17:25:37', 1, 2, NULL, 0, 4);
INSERT INTO `sys_department` VALUES ('1280010395490193410', '一级组织一', 'yy1', '1280009201233432577', '逍遥域', 1, '0', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-06 13:27:14', NULL, NULL, '2020-07-15 16:10:57', 1, 1, NULL, 0, 0);
INSERT INTO `sys_department` VALUES ('1280013702690508802', '一级组织2', '213', '1280009201233432577', '一级组织2', 0, '0', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-06 13:40:22', NULL, NULL, '2020-07-17 13:13:42', 1, 1, NULL, 0, 2);
INSERT INTO `sys_department` VALUES ('1280013887030169601', '权威', 'wqe', '0', NULL, 1, '0', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-06 13:41:06', NULL, NULL, '2020-07-15 17:06:37', 1, 1, NULL, 0, 2);
INSERT INTO `sys_department` VALUES ('1280013965623037954', '测试组织', '1223', '1280013887030169601', '权威', 0, '0', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-06 13:41:25', NULL, NULL, '2020-07-15 16:10:57', 1, 1, NULL, 0, 3);
INSERT INTO `sys_department` VALUES ('1280014257269772289', '测试二级1', '1221', '1280010395490193410', '一级组织一', 0, '0', 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-06 13:42:35', NULL, NULL, '2020-07-15 16:10:57', 1, 1, NULL, 0, 1);
INSERT INTO `sys_department` VALUES ('1295653064933453825', '逍遥域二级', '213', '1280009201233432577', '逍遥域', 0, '0', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-18 17:25:37', NULL, NULL, '2020-08-18 17:25:37', 1, 1, NULL, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE "sys_dict" (
  "id" varchar(32) NOT NULL,
  "dict_label" varchar(100) DEFAULT NULL COMMENT '字典标识（所属字典）',
  "key" varchar(100) DEFAULT '' COMMENT '索引值',
  "value" varchar(200) DEFAULT '' COMMENT '索引值对应名称',
  "paixu" int(6) NOT NULL DEFAULT '0' COMMENT '排序',
  "parent_id" varchar(40) DEFAULT '0' COMMENT '父级id',
  "description" varchar(256) DEFAULT NULL COMMENT '描述',
  "dict_type" tinyint(2) DEFAULT '0' COMMENT '字典类型 默认0：字典，1：字典详情',
  "dict_group_id" varchar(32) DEFAULT NULL COMMENT '字典分组id',
  "dep_id" varchar(32) DEFAULT NULL COMMENT '部门id',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES ('1273857840645144577', 'common_status', 'dict_label', '通用状态', 1, '0', '', 0, '1295249288795910145', NULL, NULL, NULL, '2020-06-19 13:59:11', NULL, NULL, '2020-08-18 16:39:51', 1, 0, 13);
INSERT INTO `sys_dict` VALUES ('1273878557331820546', 'sex', 'dict_label', '性别', 1, '0', NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 15:21:30', NULL, NULL, '2020-06-21 11:05:24', 1, 0, 3);
INSERT INTO `sys_dict` VALUES ('1274538534962790401', 'common_status', '0', '禁用', 1, '1273857840645144577', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-21 11:04:01', NULL, NULL, '2020-06-25 21:42:26', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1274538768128344065', 'common_status', '1', '启用', 2, '1273857840645144577', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-21 11:04:56', NULL, NULL, '2020-06-25 21:42:26', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1274540873035612162', 'sex', '0', '未知/不详', 1, '1273878557331820546', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-21 11:13:18', NULL, NULL, '2020-07-27 16:33:57', 1, 0, 1);
INSERT INTO `sys_dict` VALUES ('1274540926437490690', 'sex', '1', '男', 2, '1273878557331820546', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-21 11:13:31', NULL, NULL, '2020-06-21 11:13:31', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1274541047472521217', 'sex', '2', '女', 3, '1273878557331820546', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-21 11:14:00', NULL, NULL, '2020-06-23 16:23:10', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1275427866930130945', 'dict_type', 'dict_label', '字典类型', 1, '0', NULL, 0, NULL, NULL, NULL, NULL, '2020-06-23 21:57:54', NULL, NULL, '2020-06-23 22:07:44', 1, 0, 1);
INSERT INTO `sys_dict` VALUES ('1275430008533364737', 'dict_type', '0', '字典', 1, '1275427866930130945', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-23 22:06:25', NULL, NULL, '2020-06-23 22:08:34', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1275430081463922689', 'dict_type', '1', '字典详情', 1, '1275427866930130945', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-23 22:06:42', NULL, NULL, '2020-06-24 15:05:13', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276155443290341378', 'sys_role_type', 'dict_label', '角色类型', 1, '0', NULL, 0, NULL, NULL, NULL, NULL, '2020-06-25 22:09:02', NULL, NULL, '2020-06-25 22:09:02', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276155600757096449', 'sys_role_type', '0', '普通角色', 1, '1276155443290341378', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-25 22:09:39', NULL, NULL, '2020-06-25 22:09:39', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276155835990441986', 'sys_role_type', '16', '内置角色', 1, '1276155443290341378', '内置角色不可删除', 1, NULL, NULL, NULL, NULL, '2020-06-25 22:10:35', NULL, NULL, '2020-06-25 22:10:35', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276502068416303106', 'sys_role_use_range', 'dict_label', '角色使用范围', 1, '0', NULL, 0, NULL, NULL, NULL, NULL, '2020-06-26 21:06:24', NULL, NULL, '2020-06-28 18:42:32', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276502216097746946', 'sys_role_use_range', '0', '所有组织', 1, '1276502068416303106', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-26 21:06:59', NULL, NULL, '2020-06-26 21:06:59', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276502274331463682', 'sys_role_use_range', '1', '当前组织及以下组织', 1, '1276502068416303106', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-26 21:07:13', NULL, NULL, '2020-06-26 21:07:13', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1276502326013677569', 'sys_role_use_range', '2', '当前组织', 1, '1276502068416303106', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-26 21:07:25', NULL, NULL, '2020-06-26 21:07:25', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1277165572622151681', 'sys_department_level', '1', '一级', 1, '1277165541114540034', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-28 17:02:55', NULL, NULL, '2020-06-28 17:02:55', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1277165608164683777', 'sys_department_level', '2', '二级', 1, '1277165541114540034', NULL, 1, NULL, NULL, NULL, NULL, '2020-06-28 17:03:04', NULL, NULL, '2020-06-28 17:03:04', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1285398164702007298', 'sys_user_create_type', 'dict_label', '用户创建类型', 1, '0', NULL, 0, '1295245974771462146', NULL, NULL, NULL, '2020-07-21 10:16:18', NULL, NULL, '2020-08-17 15:24:42', 1, 0, 1);
INSERT INTO `sys_dict` VALUES ('1285398416003731457', 'sys_user_create_type', '0', '用户注册', 1, '1285398164702007298', NULL, 1, NULL, NULL, NULL, NULL, '2020-07-21 10:17:18', NULL, NULL, '2020-07-21 10:17:18', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1285398454855569409', 'sys_user_create_type', '1', '后台添加', 1, '1285398164702007298', NULL, 1, NULL, NULL, NULL, NULL, '2020-07-21 10:17:27', NULL, NULL, '2020-07-21 10:17:27', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295659891981103106', 'sys_user_dep_position_code', 'dict_label', '组织成员岗位级别', 1, '0', NULL, 0, '1295247837738692609', NULL, NULL, NULL, '2020-08-18 17:52:45', NULL, NULL, '2020-08-18 17:52:45', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295659965452726274', 'sys_user_dep_position_code', '1', 'P1', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:02', NULL, NULL, '2020-08-18 17:53:02', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660003910299649', 'sys_user_dep_position_code', '2', 'P2', 2, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:11', NULL, NULL, '2020-08-18 17:53:11', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660046864166913', 'sys_user_dep_position_code', '3', 'P3', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:22', NULL, NULL, '2020-08-18 17:53:22', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660088345833473', 'sys_user_dep_position_code', '4', 'P4', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:31', NULL, NULL, '2020-08-18 17:53:31', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660115344568322', 'sys_user_dep_position_code', '5', 'P5', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:38', NULL, NULL, '2020-08-18 17:53:38', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660143253467137', 'sys_user_dep_position_code', '6', 'P6', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:45', NULL, NULL, '2020-08-18 17:53:45', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660180373057538', 'sys_user_dep_position_code', '7', 'P7', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:53:53', NULL, NULL, '2020-08-18 17:53:53', 1, 0, 0);
INSERT INTO `sys_dict` VALUES ('1295660210827898882', 'sys_user_dep_position_code', '8', 'P8', 1, '1295659891981103106', NULL, 1, NULL, NULL, NULL, NULL, '2020-08-18 17:54:01', NULL, NULL, '2020-08-18 17:54:01', 1, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_group`;
CREATE TABLE "sys_dict_group" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "name" varchar(255) DEFAULT NULL COMMENT '分组名称',
  "parent_id" varchar(40) DEFAULT '0' COMMENT '父级id',
  "parent_name" varchar(255) DEFAULT NULL COMMENT '父级名称',
  "sub_count" int(5) unsigned DEFAULT '0' COMMENT '下级数量',
  "paixu" int(6) NOT NULL DEFAULT '0' COMMENT '排序',
  "description" varchar(256) DEFAULT NULL COMMENT '描述',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典分组';

-- ----------------------------
-- Records of sys_dict_group
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_group` VALUES ('1295227754182209537', '基础平台服务', '0', '最上级', 0, 1, '撒发生大发', NULL, NULL, '2020-08-17 13:15:35', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295228135343779842', '驱蚊器二', '1295227754182209537', '基础平台服务', 0, 1, NULL, NULL, NULL, '2020-08-17 13:17:06', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295228458204524546', '权威', '0', NULL, 0, 1, NULL, NULL, NULL, '2020-08-17 13:18:23', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295228533286760449', '切勿', '1295227754182209537', '基础平台服务', 0, 1, NULL, NULL, NULL, '2020-08-17 13:18:41', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295228568317587457', NULL, '1295227754182209537', '基础平台服务', 0, 1, NULL, NULL, NULL, '2020-08-17 13:18:49', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295228616740827138', '王企鹅群无', '1295228135343779842', '驱蚊器二', 0, 1, NULL, NULL, NULL, '2020-08-17 13:19:01', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295228684785020930', '去玩儿群无', '1295228458204524546', '权威', 0, 1, NULL, NULL, NULL, '2020-08-17 13:19:17', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295229312911405057', '驱蚊器', '0', NULL, 0, 1, NULL, NULL, NULL, '2020-08-17 13:21:47', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295229526439227393', '厄齐尔', '0', NULL, 0, 1, NULL, NULL, NULL, '2020-08-17 13:22:37', NULL, NULL, '2020-08-17 13:37:25', 1, 1, 0);
INSERT INTO `sys_dict_group` VALUES ('1295245767438626818', '基础平台服务字典', '0', NULL, 4, 1, NULL, NULL, NULL, '2020-08-17 14:27:10', NULL, NULL, '2020-08-21 16:05:23', 1, 0, 1);
INSERT INTO `sys_dict_group` VALUES ('1295245974771462146', '用户相关字典', '1295245767438626818', '基础平台服务', 0, 1, NULL, NULL, NULL, '2020-08-17 14:27:59', NULL, NULL, '2020-08-21 13:05:51', 1, 0, 0);
INSERT INTO `sys_dict_group` VALUES ('1295247733808033794', '角色相关字典', '1295245767438626818', '基础平台服务', 0, 1, NULL, NULL, NULL, '2020-08-17 14:34:58', NULL, NULL, '2020-08-17 14:34:58', 1, 0, 0);
INSERT INTO `sys_dict_group` VALUES ('1295247837738692609', '组织成员相关字典', '1295245767438626818', '基础平台服务', 0, 1, NULL, NULL, NULL, '2020-08-17 14:35:23', NULL, NULL, '2020-08-18 17:51:33', 1, 0, 1);
INSERT INTO `sys_dict_group` VALUES ('1295249288795910145', '通用字典', '1295245767438626818', '基础平台服务', 0, 10, NULL, NULL, NULL, '2020-08-17 14:41:09', NULL, NULL, '2020-08-17 14:41:09', 1, 0, 0);
INSERT INTO `sys_dict_group` VALUES ('1296678406569635842', '1', '0', NULL, 0, 1, NULL, NULL, NULL, '2020-08-21 13:19:57', NULL, NULL, '2020-08-21 13:20:28', 1, 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE "sys_menu" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "title" varchar(100) NOT NULL COMMENT '菜单名字 ',
  "code" varchar(50) DEFAULT NULL COMMENT '菜单编码，解决前后端分离时为组成名称',
  "path" varchar(1000) DEFAULT NULL COMMENT '菜单url',
  "parent_id" varchar(32) DEFAULT NULL COMMENT '父级id ',
  "sub_count" int(6) NOT NULL DEFAULT '0' COMMENT '子节点数目',
  "icon" varchar(100) DEFAULT NULL COMMENT '图标样式 ',
  "img_path" varchar(255) DEFAULT NULL COMMENT '上传图标路径',
  "permission" varchar(100) DEFAULT NULL COMMENT '权限代码，尽可能保证唯一性',
  "menu_type" tinyint(2) DEFAULT '2' COMMENT '类型   1：目录   2：菜单   4：按钮',
  "menu_adap" tinyint(2) DEFAULT '1' COMMENT '菜单适配类型(1：PC端 2：移动端 )',
  "is_outside" tinyint(2) DEFAULT '0' COMMENT '是否是外接系统,0:内网资源，1是外接资源，外链资源',
  "open_type" tinyint(2) DEFAULT '1' COMMENT 'web端打开方式，1：新页面(新窗口)打开  2:当前页面框架中打开',
  "sys_code" varchar(100) DEFAULT NULL COMMENT '系统编号 ',
  "status" tinyint(2) unsigned DEFAULT '1' COMMENT '是否是不可用的，0 不可用，1可用 ',
  "top_id" varchar(32) DEFAULT NULL COMMENT '系统id',
  "paixu" int(4) DEFAULT '0' COMMENT '排序 ',
  "dep_id" varchar(32) DEFAULT NULL COMMENT '部门id',
  "remark" varchar(500) DEFAULT NULL COMMENT '备注',
  "create_user_id" varchar(32) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(32) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(32) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(32) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统菜单资源目录';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1266710091638300674', '首页', 'Dashboard', '/', '0', 0, 'dashboard', NULL, 'dashboard', 1, 1, 0, 1, 'resource', 1, '0', 10, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-08-18 16:31:48', 0, 0);
INSERT INTO `sys_menu` VALUES ('1266715857300545538', '系统设置', 'sys', '/sys', '0', 8, 'el-icon-setting', NULL, 'sys', 1, 1, 0, 1, 'resource', 1, '0', 2, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1267285387294834689', '菜单设置', 'SysMenu', '/sys/menu', '1266715857300545538', 0, 'tree-table', NULL, 'SysMenu', 1, 1, 0, 1, 'resource', 1, '0', 1, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-06-16 13:36:42', 0, 0);
INSERT INTO `sys_menu` VALUES ('1267285387320000514', '添加', 'add', NULL, '1267285387294834689', 0, 'el-icon-plus', NULL, 'SysMenu:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-08-13 11:30:14', 0, 0);
INSERT INTO `sys_menu` VALUES ('1267285387328389122', '修改', 'edit', NULL, '1267285387294834689', 0, NULL, NULL, 'SysMenu:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-06-15 10:26:27', 0, 0);
INSERT INTO `sys_menu` VALUES ('1267285387332583425', '删除', 'del', NULL, '1267285387294834689', 0, NULL, NULL, 'SysMenu:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-06-15 10:26:27', 0, 0);
INSERT INTO `sys_menu` VALUES ('1267285387332583426', '详情', 'info', NULL, '1267285387294834689', 0, NULL, NULL, 'SysMenu:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-06-15 10:26:27', 0, 0);
INSERT INTO `sys_menu` VALUES ('1267285387340972034', '查询', 'query', NULL, '1267285387294834689', 0, NULL, NULL, 'SysMenu:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:26:27', NULL, NULL, '2020-06-15 10:26:27', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272355417699160065', '组织管理', 'SysDep', '/sys/dep', '1266715857300545538', 0, 'tree', NULL, 'SysDep', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-06-15 10:29:05', NULL, NULL, '2020-06-26 21:34:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272355417741103106', '添加', 'add', NULL, '1272355417699160065', 0, NULL, NULL, 'sysDep:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:29:05', NULL, NULL, '2020-06-15 10:29:05', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272355417757880321', '删除', 'del', NULL, '1272355417699160065', 0, NULL, NULL, 'sysDep:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:29:05', NULL, NULL, '2020-06-15 10:29:05', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272355417762074626', '详情', 'info', NULL, '1272355417699160065', 0, NULL, NULL, 'sysDep:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:29:05', NULL, NULL, '2020-06-15 10:29:05', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272355417766268930', '查询', 'query', NULL, '1272355417699160065', 0, NULL, NULL, 'sysDep:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:29:05', NULL, NULL, '2020-06-15 10:29:05', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272355417770463234', '导出', 'exp', NULL, '1272355417699160065', 0, NULL, NULL, 'sysDep:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 10:29:05', NULL, NULL, '2020-06-16 14:05:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272440148235161602', '角色管理', 'SysRole', '/sys/role', '1266715857300545538', 0, 'peoples', NULL, 'SysRole', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-06-15 16:05:46', NULL, NULL, '2020-06-16 18:52:56', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272440148251938817', '添加', 'add', NULL, '1272440148235161602', 0, NULL, NULL, 'SysRole:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 16:05:46', NULL, NULL, '2020-06-15 16:05:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272440148256133123', '删除', 'del', NULL, '1272440148235161602', 0, NULL, NULL, 'SysRole:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 16:05:46', NULL, NULL, '2020-06-15 16:05:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272440148260327425', '详情', 'info', NULL, '1272440148235161602', 0, NULL, NULL, 'SysRole:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 16:05:46', NULL, NULL, '2020-06-15 16:05:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272440148319047682', '查询', 'query', NULL, '1272440148235161602', 0, NULL, NULL, 'SysRole:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 16:05:46', NULL, NULL, '2020-06-15 16:05:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1272440148319047683', '导出', 'exp', NULL, '1272440148235161602', 0, NULL, NULL, 'SysRole:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-15 16:05:46', NULL, NULL, '2020-06-15 16:05:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052640280578', '字典管理', 'SysDictMan', '#', '1266715857300545538', 2, 'tree', NULL, 'SysDictMan', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-08-14 10:50:45', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052732555266', '添加', 'add', NULL, '1273857052640280578', 0, NULL, NULL, 'SysDict:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-06-19 13:56:03', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052740943874', '编辑', 'edit', NULL, '1273857052640280578', 0, NULL, NULL, 'SysDict:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-06-19 13:56:03', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052749332482', '删除', 'del', NULL, '1273857052640280578', 0, NULL, NULL, 'SysDict:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-06-19 13:56:03', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052753526786', '详情', 'info', NULL, '1273857052640280578', 0, NULL, NULL, 'SysDict:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-06-19 13:56:03', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052757721089', '查询', 'query', NULL, '1273857052640280578', 0, NULL, NULL, 'SysDict:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-06-19 13:56:03', 0, 0);
INSERT INTO `sys_menu` VALUES ('1273857052761915393', '导出', 'exp', NULL, '1273857052640280578', 0, NULL, NULL, 'SysDict:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-06-19 13:56:03', NULL, NULL, '2020-06-19 13:56:03', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477432115202', '用户中心', 'SysUser', '/sys/user', '1266715857300545538', 0, 'tree', NULL, 'SysUser', 1, 0, 0, 1, 'resource', 1, '0', 1, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:15:39', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477499224065', '添加', 'add', NULL, '1285124477432115202', 0, NULL, NULL, 'SysUser:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:08:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477507612674', '编辑', 'edit', NULL, '1285124477432115202', 0, NULL, NULL, 'SysUser:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:08:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477511806978', '删除', 'del', NULL, '1285124477432115202', 0, NULL, NULL, 'SysUser:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:08:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477516001282', '详情', 'info', NULL, '1285124477432115202', 0, NULL, NULL, 'SysUser:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:08:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477516001283', '查询', 'query', NULL, '1285124477432115202', 0, NULL, NULL, 'SysUser:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:08:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1285124477520195585', '导出', 'exp', NULL, '1285124477432115202', 0, NULL, NULL, 'SysUser:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-07-20 16:08:46', NULL, NULL, '2020-07-20 16:08:46', 0, 0);
INSERT INTO `sys_menu` VALUES ('1287917309985357825', '编辑', 'edit', '#', '1272355417699160065', 0, 'el-icon-edit', NULL, 'null:edit', 4, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-07-28 09:06:29', NULL, NULL, '2020-07-28 09:06:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1287917531205533698', '编辑', 'edit', '#', '1272440148235161602', 0, 'tree', NULL, 'null:edit', 4, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-07-28 09:07:22', NULL, NULL, '2020-07-28 09:07:22', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569404974714881', '成员管理', 'SysDepUser', '/sys/depUser', '1266715857300545538', 0, 'el-icon-s-custom', NULL, 'SysDepUser', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:45:30', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569405046018050', '添加', 'add', NULL, '1290569404974714881', 0, NULL, NULL, 'SysDepUser:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:44:58', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569405050212353', '编辑', 'edit', NULL, '1290569404974714881', 0, NULL, NULL, 'SysDepUser:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:44:58', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569405050212354', '删除', 'del', NULL, '1290569404974714881', 0, NULL, NULL, 'SysDepUser:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:44:58', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569405054406658', '详情', 'info', NULL, '1290569404974714881', 0, NULL, NULL, 'SysDepUser:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:44:58', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569405054406659', '查询', 'query', NULL, '1290569404974714881', 0, NULL, NULL, 'SysDepUser:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:44:58', 0, 0);
INSERT INTO `sys_menu` VALUES ('1290569405058600962', '导出', 'exp', NULL, '1290569404974714881', 0, NULL, NULL, 'SysDepUser:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-04 16:44:58', NULL, NULL, '2020-08-04 16:44:58', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104174157825', '岗位管理', 'SysStation', '/sys/station', '1266715857300545538', 0, 'el-icon-notebook-2', NULL, 'SysStation', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104270626817', '添加', 'add', NULL, '1293122104174157825', 0, NULL, NULL, 'SysStation:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104283209729', '编辑', 'edit', NULL, '1293122104174157825', 0, NULL, NULL, 'SysStation:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104287404034', '删除', 'del', NULL, '1293122104174157825', 0, NULL, NULL, 'SysStation:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104287404035', '详情', 'info', NULL, '1293122104174157825', 0, NULL, NULL, 'SysStation:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104291598337', '查询', 'query', NULL, '1293122104174157825', 0, NULL, NULL, 'SysStation:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1293122104295792641', '导出', 'exp', NULL, '1293122104174157825', 0, NULL, NULL, 'SysStation:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-11 17:48:29', NULL, NULL, '2020-08-11 17:48:29', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458701414402', '字典配置', 'SysDict', '/sys/dict', '1273857052640280578', 0, 'tree', NULL, 'SysDict', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 11:14:13', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458890158082', '添加', 'add', NULL, '1294103458701414402', 0, NULL, NULL, 'SysDict:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 10:48:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458911129601', '编辑', 'edit', NULL, '1294103458701414402', 0, NULL, NULL, 'SysDict:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 10:48:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458911129602', '删除', 'del', NULL, '1294103458701414402', 0, NULL, NULL, 'SysDict:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 10:48:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458915323906', '详情', 'info', NULL, '1294103458701414402', 0, NULL, NULL, 'SysDict:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 10:48:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458915323907', '查询', 'query', NULL, '1294103458701414402', 0, NULL, NULL, 'SysDict:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 10:48:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103458919518209', '导出', 'exp', NULL, '1294103458701414402', 0, NULL, NULL, 'SysDict:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:48:02', NULL, NULL, '2020-08-14 10:48:02', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752831176706', '字典分组', 'SysDictGroup', '/sys/dictgroup', '1273857052640280578', 0, 'tree', NULL, 'SysDictGroup', 1, 1, 0, 1, NULL, 1, NULL, 2, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:57:25', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752852148226', '添加', 'add', NULL, '1294103752831176706', 0, NULL, NULL, 'SysDictGroup:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:49:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752860536833', '编辑', 'edit', NULL, '1294103752831176706', 0, NULL, NULL, 'SysDictGroup:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:49:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752860536834', '删除', 'del', NULL, '1294103752831176706', 0, NULL, NULL, 'SysDictGroup:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:49:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752860536835', '详情', 'info', NULL, '1294103752831176706', 0, NULL, NULL, 'SysDictGroup:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:49:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752860536836', '查询', 'query', NULL, '1294103752831176706', 0, NULL, NULL, 'SysDictGroup:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:49:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294103752868925442', '导出', 'exp', NULL, '1294103752831176706', 0, NULL, NULL, 'SysDictGroup:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 10:49:12', NULL, NULL, '2020-08-14 10:49:12', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114115190644738', '外挂系统', 'wg1', '#', '0', 3, 'tree', NULL, 'wg1', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-14 11:30:23', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641827454977', 'mybatisplus文档', 'mybatisplus', 'http://mybatisplus.itkjb.com/', '1294114115190644738', 0, 'tree', NULL, 'mybatisplus', 1, 1, 1, 2, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-21 10:11:57', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641877786625', '添加', 'add', NULL, '1294114641827454977', 0, NULL, NULL, 'mybatisplus:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-14 11:32:28', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641881980930', '编辑', 'edit', NULL, '1294114641827454977', 0, NULL, NULL, 'mybatisplus:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-14 11:32:28', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641881980931', '删除', 'del', NULL, '1294114641827454977', 0, NULL, NULL, 'mybatisplus:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-14 11:32:28', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641886175233', '详情', 'info', NULL, '1294114641827454977', 0, NULL, NULL, 'mybatisplus:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-14 11:32:28', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641886175234', '查询', 'query', NULL, '1294114641827454977', 0, NULL, NULL, 'mybatisplus:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-14 11:32:28', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294114641886175235', '导出', 'exp', NULL, '1294114641827454977', 0, NULL, NULL, 'mybatisplus:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:32:28', NULL, NULL, '2020-08-14 11:32:28', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005586857985', '新页面打开', 'newpage', 'https://element.eleme.cn/#/zh-CN/component/switch', '1294114115190644738', 0, 'tree', NULL, 'newpage', 1, 1, 1, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 12:07:05', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005616218113', '添加', 'add', NULL, '1294115005586857985', 0, NULL, NULL, 'newpage:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 11:33:55', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005620412417', '编辑', 'edit', NULL, '1294115005586857985', 0, NULL, NULL, 'newpage:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 11:33:55', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005620412418', '删除', 'del', NULL, '1294115005586857985', 0, NULL, NULL, 'newpage:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 11:33:55', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005620412419', '详情', 'info', NULL, '1294115005586857985', 0, NULL, NULL, 'newpage:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 11:33:55', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005624606721', '查询', 'query', NULL, '1294115005586857985', 0, NULL, NULL, 'newpage:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 11:33:55', 0, 0);
INSERT INTO `sys_menu` VALUES ('1294115005628801026', '导出', 'exp', NULL, '1294115005586857985', 0, NULL, NULL, 'newpage:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-14 11:33:55', NULL, NULL, '2020-08-14 11:33:55', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097427472385', 'tree_select', 'tree_select', 'https://www.vue-treeselect.cn/#node', '1294114115190644738', 0, 'tree', NULL, 'tree_select', 1, 1, 1, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 16:02:22', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097490386945', '添加', 'add', NULL, '1295259097427472385', 0, NULL, NULL, 'tree_select:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097498775553', '编辑', 'edit', NULL, '1295259097427472385', 0, NULL, NULL, 'tree_select:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097502969857', '删除', 'del', NULL, '1295259097427472385', 0, NULL, NULL, 'tree_select:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097502969858', '详情', 'info', NULL, '1295259097427472385', 0, NULL, NULL, 'tree_select:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097507164161', '查询', 'query', NULL, '1295259097427472385', 0, NULL, NULL, 'tree_select:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1295259097511358466', '导出', 'exp', NULL, '1295259097427472385', 0, NULL, NULL, 'tree_select:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-17 15:20:08', NULL, NULL, '2020-08-17 15:20:08', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491593510913', '菜单管理2', 'SysMenu', '/sys/menu', '1266715857300545538', 0, 'tree', NULL, 'SysMenu', 1, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:50:35', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491698368513', '添加', 'add', NULL, '1296624491593510913', 0, NULL, NULL, 'SysMenu:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491715145730', '编辑', 'edit', NULL, '1296624491593510913', 0, NULL, NULL, 'SysMenu:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491719340034', '删除', 'del', NULL, '1296624491593510913', 0, NULL, NULL, 'SysMenu:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491723534338', '详情', 'info', NULL, '1296624491593510913', 0, NULL, NULL, 'SysMenu:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491727728641', '查询', 'query', NULL, '1296624491593510913', 0, NULL, NULL, 'SysMenu:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296624491731922945', '导出', 'exp', NULL, '1296624491593510913', 0, NULL, NULL, 'SysMenu:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:45:43', NULL, NULL, '2020-08-21 09:45:43', 0, 0);
INSERT INTO `sys_menu` VALUES ('1296626902252957697', '444', '444', 'https://www.baidu.com/', '1294114641827454977', 0, 'tree', NULL, '444', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296626902282317826', '添加', 'add', NULL, '1296626902252957697', 0, NULL, NULL, '444:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296626902290706434', '编辑', 'edit', NULL, '1296626902252957697', 0, NULL, NULL, '444:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296626902290706435', '删除', 'del', NULL, '1296626902252957697', 0, NULL, NULL, '444:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296626902290706436', '详情', 'info', NULL, '1296626902252957697', 0, NULL, NULL, '444:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296626902294900738', '查询', 'query', NULL, '1296626902252957697', 0, NULL, NULL, '444:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296626902299095042', '导出', 'exp', NULL, '1296626902252957697', 0, NULL, NULL, '444:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:55:18', NULL, NULL, '2020-08-21 10:11:57', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084763901953', '555', '555', 'https://www.baidu.com/', '1294114641827454977', 0, 'tree', NULL, '555', 1, 1, 0, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084797456386', '添加', 'add', NULL, '1296627084763901953', 0, NULL, NULL, '555:add', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084805844994', '编辑', 'edit', NULL, '1296627084763901953', 0, NULL, NULL, '555:edit', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084805844995', '删除', 'del', NULL, '1296627084763901953', 0, NULL, NULL, '555:del', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084805844996', '详情', 'info', NULL, '1296627084763901953', 0, NULL, NULL, '555:info', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084814233601', '查询', 'query', NULL, '1296627084763901953', 0, NULL, NULL, '555:query', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
INSERT INTO `sys_menu` VALUES ('1296627084814233602', '导出', 'exp', NULL, '1296627084763901953', 0, NULL, NULL, '555:exp', 4, 1, 0, 1, NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, '2020-08-21 09:56:01', NULL, NULL, '2020-08-21 10:11:45', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE "sys_role" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "name" varchar(255) NOT NULL COMMENT '角色名称',
  "code" varchar(40) DEFAULT NULL COMMENT '角色代码',
  "dep_id" varchar(40) DEFAULT NULL COMMENT '组织id',
  "status" tinyint(2) DEFAULT '1' COMMENT '状态  1 启用  0 禁用',
  "paixu" int(4) DEFAULT '0' COMMENT '排序',
  "remark" varchar(500) DEFAULT NULL COMMENT '备注',
  "type" tinyint(2) DEFAULT '0' COMMENT '角色类型 0：普通角色 ；16：系统内置角色不可删除',
  "use_range" tinyint(2) DEFAULT '0' COMMENT '使用范围 0：所有组织可用， 1：当前组织以及下级组织可用，2：仅限当前组织可用',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人名称',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '管理员', 'admin', '1280009201233432577', 1, 0, 'string', 16, 0, NULL, NULL, '2020-06-12 23:02:19', NULL, NULL, '2020-08-13 09:17:06', 0, 5);
INSERT INTO `sys_role` VALUES ('1273069699004940290', '测试', '2131', '1280010395490193410', 1, 1, '123', 0, 0, NULL, NULL, '2020-06-17 09:47:23', NULL, NULL, '2020-08-13 09:17:12', 0, 1223372036854775808);
INSERT INTO `sys_role` VALUES ('1273073500357177345', '123', '123', '1280010395490193410', 1, 1, NULL, 0, 0, NULL, NULL, '2020-06-17 10:02:29', NULL, NULL, '2020-08-13 09:34:44', 0, 1);
INSERT INTO `sys_role` VALUES ('1273073667860901889', '12313', '1231', '1280013702690508802', 1, 1, NULL, 0, 0, NULL, NULL, '2020-06-17 10:03:09', NULL, NULL, '2020-08-13 09:34:49', 0, 1);
INSERT INTO `sys_role` VALUES ('1273073694335348737', '1231', '313', '1280014257269772289', 1, 1, NULL, 0, 0, NULL, NULL, '2020-06-17 10:03:15', NULL, NULL, '2020-08-13 09:34:56', 0, 1);
INSERT INTO `sys_role` VALUES ('1276136310859399170', 'test', 'test', '1280014257269772289', 1, 1, NULL, 0, 0, NULL, NULL, '2020-06-25 20:53:00', NULL, NULL, '2020-08-13 09:35:12', 0, 2);
INSERT INTO `sys_role` VALUES ('1276136463544647681', 'testst', 'tstes', '1280014257269772289', 1, 1, NULL, 0, 0, NULL, NULL, '2020-06-25 20:53:37', NULL, NULL, '2020-08-13 09:35:19', 0, 1);
INSERT INTO `sys_role` VALUES ('1277162645874569218', 'qweqw', '2131', '1280014257269772289', 1, 1, NULL, 0, 0, NULL, NULL, '2020-06-28 16:51:17', NULL, NULL, '2020-08-13 09:35:26', 0, 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE "sys_role_menu" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "role_id" varchar(32) NOT NULL COMMENT '角色id',
  "menu_id" varchar(32) NOT NULL COMMENT '菜单id',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  PRIMARY KEY ("id") USING BTREE,
  KEY "sy_sys_rm_role_id" ("role_id") USING BTREE,
  KEY "index_role_menu_menu_id" ("menu_id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='角色绑定菜单';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('1288309612008792066', '1273069699004940290', '1266715857300545538', NULL, NULL, '2020-07-29 11:05:21', NULL, NULL, '2020-07-29 11:05:21', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309612017180673', '1273069699004940290', '1267285387320000514', NULL, NULL, '2020-07-29 11:05:21', NULL, NULL, '2020-07-29 11:05:21', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309612017180674', '1273069699004940290', '1267285387328389122', NULL, NULL, '2020-07-29 11:05:21', NULL, NULL, '2020-07-29 11:05:21', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309612017180675', '1273069699004940290', '1267285387332583426', NULL, NULL, '2020-07-29 11:05:21', NULL, NULL, '2020-07-29 11:05:21', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309612021374977', '1273069699004940290', '1267285387340972034', NULL, NULL, '2020-07-29 11:05:21', NULL, NULL, '2020-07-29 11:05:21', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309612021374978', '1273069699004940290', '1267285387294834689', NULL, NULL, '2020-07-29 11:05:21', NULL, NULL, '2020-07-29 11:05:21', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659811274754', '1273073500357177345', '1267285387320000514', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659815469058', '1273073500357177345', '1267285387328389122', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659815469059', '1273073500357177345', '1267285387340972034', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659815469060', '1273073500357177345', '1272355417699160065', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659815469061', '1273073500357177345', '1272355417741103106', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659823857665', '1273073500357177345', '1272355417757880321', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659823857666', '1273073500357177345', '1272355417762074626', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659823857667', '1273073500357177345', '1272355417766268930', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659823857668', '1273073500357177345', '1272355417770463234', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659823857669', '1273073500357177345', '1287917309985357825', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659828051970', '1273073500357177345', '1272440148235161602', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659828051971', '1273073500357177345', '1272440148251938817', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659836440577', '1273073500357177345', '1272440148256133123', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659836440578', '1273073500357177345', '1272440148260327425', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659836440579', '1273073500357177345', '1272440148319047682', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659840634882', '1273073500357177345', '1272440148319047683', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659840634883', '1273073500357177345', '1287917531205533698', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659840634884', '1273073500357177345', '1266715857300545538', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1288309659844829186', '1273073500357177345', '1267285387294834689', NULL, NULL, '2020-07-29 11:05:33', NULL, NULL, '2020-07-29 11:05:33', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244260257794', '1', '1266710091638300674', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244268646401', '1', '1266715857300545538', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244272840705', '1', '1267285387294834689', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244272840706', '1', '1267285387320000514', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244277035010', '1', '1267285387328389122', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244277035011', '1', '1267285387332583425', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244281229313', '1', '1267285387332583426', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244281229314', '1', '1267285387340972034', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244285423618', '1', '1272355417699160065', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244285423619', '1', '1287917309985357825', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244289617922', '1', '1272355417741103106', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244289617923', '1', '1272355417757880321', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244289617924', '1', '1272355417762074626', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244293812226', '1', '1272355417766268930', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244293812227', '1', '1272355417770463234', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244293812228', '1', '1272440148235161602', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244302200834', '1', '1287917531205533698', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244302200835', '1', '1272440148251938817', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244306395138', '1', '1272440148256133123', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244306395139', '1', '1272440148260327425', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244306395140', '1', '1272440148319047682', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244310589441', '1', '1272440148319047683', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244310589442', '1', '1273857052640280578', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244310589443', '1', '1294103752831176706', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244310589444', '1', '1294103752852148226', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244314783746', '1', '1294103752860536833', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244314783747', '1', '1294103752860536834', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244314783748', '1', '1294103752860536835', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244318978049', '1', '1294103752860536836', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244318978050', '1', '1294103752868925442', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244318978051', '1', '1294103458701414402', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244323172353', '1', '1294103458890158082', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244323172354', '1', '1294103458911129601', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244323172355', '1', '1294103458911129602', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244327366658', '1', '1294103458915323906', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244327366659', '1', '1294103458915323907', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244327366660', '1', '1294103458919518209', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244331560962', '1', '1273857052732555266', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244331560963', '1', '1273857052740943874', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244331560964', '1', '1273857052749332482', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244335755266', '1', '1273857052753526786', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244335755267', '1', '1273857052757721089', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244335755268', '1', '1273857052761915393', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244335755269', '1', '1285124477432115202', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244339949570', '1', '1285124477499224065', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244339949571', '1', '1285124477507612674', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244339949572', '1', '1285124477511806978', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244344143873', '1', '1285124477516001282', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244344143874', '1', '1285124477516001283', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244344143875', '1', '1285124477520195585', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244348338177', '1', '1290569404974714881', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244348338178', '1', '1290569405046018050', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244348338179', '1', '1290569405050212353', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244352532482', '1', '1290569405050212354', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244352532483', '1', '1290569405054406658', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244352532484', '1', '1290569405054406659', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244352532485', '1', '1290569405058600962', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244356726786', '1', '1293122104174157825', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244356726787', '1', '1293122104270626817', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244356726788', '1', '1293122104283209729', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244360921090', '1', '1293122104287404034', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244360921091', '1', '1293122104287404035', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244360921092', '1', '1293122104291598337', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244365115394', '1', '1293122104295792641', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244365115395', '1', '1294114115190644738', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244365115396', '1', '1294114641827454977', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244369309697', '1', '1294114641877786625', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244369309698', '1', '1294114641881980930', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244369309699', '1', '1294114641881980931', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244369309700', '1', '1294114641886175233', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244373504001', '1', '1294114641886175234', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244373504002', '1', '1294114641886175235', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244373504003', '1', '1294115005586857985', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244373504004', '1', '1294115005616218113', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244377698305', '1', '1294115005620412417', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244377698306', '1', '1294115005620412418', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244377698307', '1', '1294115005620412419', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244381892609', '1', '1294115005624606721', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244381892610', '1', '1294115005628801026', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244381892611', '1', '1295259097427472385', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244381892612', '1', '1295259097490386945', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244381892613', '1', '1295259097498775553', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244386086914', '1', '1295259097502969857', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244386086915', '1', '1295259097502969858', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244390281218', '1', '1295259097507164161', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244390281219', '1', '1295259097511358466', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244394475521', '1', '1294114115220004866', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244394475522', '1', '1294114115228393473', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244394475523', '1', '1294114115232587778', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244394475524', '1', '1294114115236782081', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244398669826', '1', '1294114115236782082', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
INSERT INTO `sys_role_menu` VALUES ('1295655244398669827', '1', '1294114115236782083', NULL, NULL, '2020-08-18 17:34:17', NULL, NULL, '2020-08-18 17:34:17', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_station
-- ----------------------------
DROP TABLE IF EXISTS `sys_station`;
CREATE TABLE "sys_station" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "name" varchar(255) NOT NULL COMMENT '岗位名称',
  "code" varchar(50) DEFAULT NULL COMMENT '岗位编码',
  "topid" varchar(32) NOT NULL DEFAULT '0' COMMENT '限定组织的顶级id',
  "dep_id" varchar(32) NOT NULL COMMENT '组织id',
  "paixu" int(6) NOT NULL DEFAULT '0' COMMENT '排序',
  "status" tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态  0：禁用 ，1： 可用',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人姓名',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人Id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人名称',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='岗位';

-- ----------------------------
-- Records of sys_station
-- ----------------------------
BEGIN;
INSERT INTO `sys_station` VALUES ('1293122582538723329', '技术总监', 'jkcode', '1', '1280010395490193410', 1, 1, NULL, NULL, '2020-08-11 17:50:23', NULL, NULL, '2020-08-12 15:37:44', 0, 1);
INSERT INTO `sys_station` VALUES ('1293450653963755521', 'ceshi', NULL, '0', '1280010395490193410', 1, 1, NULL, NULL, '2020-08-12 15:34:01', NULL, NULL, '2020-08-19 15:55:13', 0, 0);
INSERT INTO `sys_station` VALUES ('1293454609871904769', '阿斯顿发', NULL, '0', '1280010395490193410', 1, 1, NULL, NULL, '2020-08-12 15:49:44', NULL, NULL, '2020-08-12 15:49:44', 0, 0);
INSERT INTO `sys_station` VALUES ('1293455535869370370', 'dsffs', NULL, '0', '1280013702690508802', 1, 1, NULL, NULL, '2020-08-12 15:53:25', NULL, NULL, '2020-08-12 15:53:25', 0, 0);
INSERT INTO `sys_station` VALUES ('1293455572758274049', 'sfafa', NULL, '0', '1280010395490193410', 1, 1, NULL, NULL, '2020-08-12 15:53:34', NULL, NULL, '2020-08-12 15:53:34', 0, 0);
INSERT INTO `sys_station` VALUES ('1295992692936900609', '总经理', NULL, '0', '1280009201233432577', 1, 1, NULL, NULL, '2020-08-19 15:55:11', NULL, NULL, '2020-08-19 15:55:11', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_station_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_station_role`;
CREATE TABLE "sys_station_role" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "station_id" varchar(32) NOT NULL COMMENT '岗位id',
  "role_id" varchar(32) NOT NULL COMMENT '角色id',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) DEFAULT NULL COMMENT '是否删除，默认0(0 未删除，1已删除)',
  PRIMARY KEY ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='岗位绑定角色';

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE "sys_user" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "username" varchar(255) NOT NULL COMMENT '用户名',
  "password" varchar(255) DEFAULT NULL COMMENT '密码',
  "mobile" varchar(255) DEFAULT NULL COMMENT '手机号',
  "email" varchar(50) DEFAULT NULL COMMENT '邮箱',
  "nickname" varchar(255) DEFAULT NULL COMMENT '显示的名字',
  "create_type" tinyint(3) DEFAULT '1' COMMENT '创建类型 1：后台添加 ，0: 用户注册',
  "def_depid" varchar(32) DEFAULT NULL COMMENT '默认组织id',
  "last_login" datetime DEFAULT NULL COMMENT '最后登陆时间',
  "last_ip" varchar(100) DEFAULT NULL COMMENT '最后一次登陆ip',
  "last_ip_des" varchar(50) DEFAULT NULL COMMENT '最后一次登录ip地址描述',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(100) DEFAULT NULL COMMENT '创建人姓名',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人Id',
  "update_user_name" varchar(100) DEFAULT NULL COMMENT '修改人名称',
  "status" tinyint(3) NOT NULL DEFAULT '8' COMMENT '状态 1 创建，注册；2：待完善信息 ；4：待补充调整信息  8：正常 16：账户冻结',
  "is_del" tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE,
  UNIQUE KEY "name" ("username")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1285398716114571266', 'xiaoyao', '$2a$10$ZQaHwQxzjw5noAdP0jzUk.PxnWhvNLJSBHOKEKk/8UJEcFJhzUjde', '1313113', '13131', '逍遥', 1, NULL, NULL, NULL, NULL, '2020-07-21 10:18:30', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 8);
INSERT INTO `sys_user` VALUES ('1286556044343918593', 'admin', '$2a$10$.d0bSl8OlXaK3xsahzStK.ELn0IdsezAYyKJLXnC./RWrV0Xr2Uyy', '18618888888', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2020-07-24 14:57:18', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011328014368769', 'aaaad', '$2a$10$sQYQV6MXUEMtqWDRqI87EedLcBoqvqcGh4ockBDhTj8gfHmzNzjN2', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2020-07-31 09:33:43', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011364496424962', 'adfa', '$2a$10$v8ppVGFJ92h016I/5ehO3uY81bRRdpQMnpMG6VY6P6PsJqKtHn67u', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '2020-07-31 09:33:52', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011507585105922', '18618336661', '$2a$10$Y9aW6fRHtiwzrEbMkw7TsODpSAjeHCVx.FyMpRsBMpwwTMHJFKSKO', '18618336661', NULL, '18618336661', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:34:26', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011586903588865', '18618336662', '$2a$10$60hLzXQI6Dm7ah/mNNsCC.RWFZmyY6zjdq4UuYdjTEIGBUiJVIw1K', '18618336662', '', '18618336662', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:34:45', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011649960755202', '18618336663', '$2a$10$bjZM9/pUeQZwvt4Hr7fl1eHBXdQDR8ir2YYNSN4nJliDEePX/BctO', '18618336663', '', '18618336663', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:35:00', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011698417549313', '18618336664', '$2a$10$3ynZ0cpOt7oSdj7O5e7gIeQTpIdW.TEc.3pR.mZ9.jHr6tSeP7jEy', '18618336664', NULL, '18618336664', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:35:12', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011761646682114', '18618336665', '$2a$10$CORuphjdxwF0S0vEjlmEhOLERzqFMtf0.kdeWbHsdimLISzkZJjc2', '18618336665', NULL, '6665', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:35:27', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011835625816066', '6667', '$2a$10$6sOwZsbn9iITsha0yMiBxuj54Z1/t/gs5YeJ7qMJX4z6xsl5QApEm', '18618336667', NULL, '6667', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:35:44', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289011903066030082', '6668', '$2a$10$VHS9.bKa0MD6bMRXEM153eOLCXVlhryv5Sw1reEBO10oeoB4.VZpW', '6668', NULL, '6668', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:36:01', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
INSERT INTO `sys_user` VALUES ('1289012012986155010', '6669', '$2a$10$0VMXY41jBU2mjkyQii17z.8oaDQx.L.bXrNT0R8Qy2V3n8uTijxuG', '6669', NULL, '6669', 1, NULL, NULL, NULL, NULL, '2020-07-31 09:36:27', NULL, NULL, '2020-08-07 17:36:59', NULL, NULL, 8, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_dep
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_dep`;
CREATE TABLE "sys_user_dep" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "user_id" varchar(32) NOT NULL COMMENT '用户id',
  "dep_id" varchar(32) DEFAULT NULL COMMENT '组织id',
  "member_name" varchar(255) DEFAULT NULL COMMENT '用户成员名称',
  "station_id" varchar(32) DEFAULT NULL COMMENT '岗位id',
  "station_name" varchar(32) DEFAULT NULL COMMENT '岗位名称',
  "user_position" varchar(255) DEFAULT NULL COMMENT '用户岗位职级',
  "position_code" tinyint(2) DEFAULT NULL COMMENT '岗位职级编号，例如1，2，3',
  "user_employee_num" varchar(50) DEFAULT NULL COMMENT '用户员工编号',
  "link_address" varchar(255) DEFAULT NULL COMMENT '联系地址',
  "data_level" tinyint(2) DEFAULT '1' COMMENT '数据权限 1 查看个人数据  2 查看本部门数据 4.当前组织以及下级数据 8:查看指定部门数据',
  "remark" varchar(500) DEFAULT NULL COMMENT '备注',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  "status" tinyint(3) NOT NULL DEFAULT '1' COMMENT '0：申请加入，待审核；1：正常；2：审核不通过，待完善信息；   -1 ：离职，删除',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE,
  KEY "idx_sys_user_dep_dep_id" ("dep_id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户组织关系对象，组织成员';

-- ----------------------------
-- Records of sys_user_dep
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_dep` VALUES ('1296020904597356545', '1285398716114571266', '1280009201233432577', '逍遥', '1295992692936900609', NULL, NULL, 1, '003', NULL, 2, NULL, NULL, NULL, '2020-08-19 17:47:17', NULL, NULL, '2020-08-20 09:07:09', 1, 0, 3);
INSERT INTO `sys_user_dep` VALUES ('1296033671618330625', '1286556044343918593', '1280009201233432577', 'admin', '1293450653963755521', NULL, NULL, 1, '001', NULL, 2, NULL, NULL, NULL, '2020-08-19 18:38:01', NULL, NULL, '2020-08-20 09:06:52', 1, 0, 6);
INSERT INTO `sys_user_dep` VALUES ('1296034745347571713', '1286556044343918593', '1280010395490193410', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, '2020-08-19 18:42:17', NULL, NULL, '2020-08-19 18:42:17', 1, 0, 0);
INSERT INTO `sys_user_dep` VALUES ('1296034822879281154', '1289011328014368769', '1280010395490193410', 'qwee', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, '2020-08-19 18:42:35', NULL, NULL, '2020-08-19 18:42:35', 1, 0, 0);
INSERT INTO `sys_user_dep` VALUES ('1296034835902595073', '1289011364496424962', '1280010395490193410', 'qweq', NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, '2020-08-19 18:42:38', NULL, NULL, '2020-08-19 18:42:38', 1, 0, 0);
INSERT INTO `sys_user_dep` VALUES ('2', '1285398716114571266', '1280010395490193410', NULL, '11', '1212', '12', NULL, NULL, NULL, 1, NULL, NULL, NULL, '2020-08-07 09:51:56', NULL, NULL, '2020-08-07 09:52:03', 1, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_info`;
CREATE TABLE "sys_user_info" (
  "id" varchar(32) NOT NULL COMMENT '用户关联id',
  "name" varchar(100) DEFAULT NULL COMMENT '姓名',
  "id_card_no" varchar(50) DEFAULT NULL COMMENT '身份证号',
  "passport_no" varchar(50) DEFAULT NULL COMMENT '护照号',
  "link_phone" varchar(50) DEFAULT NULL COMMENT '联系电话',
  "sex" tinyint(1) DEFAULT '0' COMMENT '1：男 2：女 0：不详',
  "province_id" varchar(40) DEFAULT NULL COMMENT '省id',
  "city_id" varchar(40) DEFAULT NULL COMMENT '市id',
  "county_id" varchar(40) DEFAULT NULL COMMENT '县id',
  "county_name" varchar(250) DEFAULT NULL COMMENT '县级以上名字，中间用-分割',
  "address" varchar(200) DEFAULT NULL COMMENT '详细地址',
  "qq_no" varchar(50) DEFAULT NULL COMMENT 'qq号',
  "weixi_no" varchar(50) DEFAULT NULL COMMENT '微信号',
  "avatar" varchar(500) DEFAULT NULL COMMENT '头像',
  "remark" varchar(500) DEFAULT NULL COMMENT '备注',
  "lock_version" bigint(19) unsigned NOT NULL DEFAULT '0' COMMENT '乐观锁版本号',
  KEY "sys_user_info_idi" ("id") USING BTREE,
  CONSTRAINT "sys_user_info_fki" FOREIGN KEY ("id") REFERENCES "sys_user" ("id") ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户详情';

-- ----------------------------
-- Records of sys_user_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_info` VALUES ('1285398716114571266', '李逍遥', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3);
INSERT INTO `sys_user_info` VALUES ('1289011328014368769', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011364496424962', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011507585105922', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011586903588865', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011649960755202', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011698417549313', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011761646682114', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011835625816066', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289011903066030082', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `sys_user_info` VALUES ('1289012012986155010', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE "sys_user_role" (
  "id" varchar(32) NOT NULL,
  "role_id" varchar(32) DEFAULT NULL COMMENT '角色id',
  "user_id" varchar(32) DEFAULT NULL COMMENT '用户id',
  "dep_id" varchar(32) DEFAULT NULL COMMENT '组织id 预留',
  "create_user_id" varchar(40) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(40) DEFAULT NULL COMMENT '创建人',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(40) DEFAULT NULL COMMENT '修改人id',
  "update_user_name" varchar(40) DEFAULT NULL COMMENT '修改人',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  PRIMARY KEY ("id") USING BTREE,
  KEY "FK_sys_role_id" ("role_id") USING BTREE,
  KEY "FK_sys_user_id" ("user_id") USING BTREE,
  CONSTRAINT "FK_sys_role_id" FOREIGN KEY ("role_id") REFERENCES "sys_role" ("id"),
  CONSTRAINT "FK_sys_user_id" FOREIGN KEY ("user_id") REFERENCES "sys_user" ("id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户绑定角色';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1', '1', '1285398716114571266', NULL, NULL, NULL, '2020-07-30 14:26:05', NULL, NULL, '2020-07-30 14:26:05', 0);
INSERT INTO `sys_user_role` VALUES ('1289780520464437249', '1', '1286556044343918593', NULL, NULL, NULL, '2020-08-02 12:30:13', NULL, NULL, '2020-08-02 12:30:13', 0);
INSERT INTO `sys_user_role` VALUES ('1289783141078171650', '1273069699004940290', '1285398716114571266', NULL, NULL, NULL, '2020-08-02 12:40:38', NULL, NULL, '2020-08-02 12:40:38', 0);
INSERT INTO `sys_user_role` VALUES ('1289783152276963329', '1273069699004940290', '1286556044343918593', NULL, NULL, NULL, '2020-08-02 12:40:41', NULL, NULL, '2020-08-02 12:40:41', 0);
INSERT INTO `sys_user_role` VALUES ('1290206339036958722', '1273069699004940290', '1289011507585105922', NULL, NULL, NULL, '2020-08-03 16:42:16', NULL, NULL, '2020-08-03 16:42:16', 0);
INSERT INTO `sys_user_role` VALUES ('1290206339045347329', '1273069699004940290', '1289011586903588865', NULL, NULL, NULL, '2020-08-03 16:42:16', NULL, NULL, '2020-08-03 16:42:16', 0);
INSERT INTO `sys_user_role` VALUES ('1290206339049541633', '1273069699004940290', '1289011649960755202', NULL, NULL, NULL, '2020-08-03 16:42:16', NULL, NULL, '2020-08-03 16:42:16', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_upt_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_upt_log`;
CREATE TABLE "sys_user_upt_log" (
  "id" varchar(32) NOT NULL COMMENT 'id',
  "user_id" varchar(255) NOT NULL COMMENT '用户id',
  "username" varchar(255) NOT NULL COMMENT '用户名',
  "opt_type" tinyint(2) DEFAULT '1' COMMENT '操作类型 1:修改信息，2: 修改状态',
  "opt_msg" varchar(255) NOT NULL COMMENT '操作信息',
  "bef_status" tinyint(3) NOT NULL DEFAULT '0' COMMENT '修改前状态 1 创建，注册；2：待完善信息 ；4：待补充调整信息  8：正常 16：账户冻结',
  "aft_status" tinyint(3) NOT NULL DEFAULT '0' COMMENT '修改后状态 1 创建，注册；2：待完善信息 ；4：待补充调整信息  8：正常 16：账户冻结',
  "create_user_id" varchar(32) DEFAULT NULL COMMENT '创建人id',
  "create_user_name" varchar(100) DEFAULT NULL COMMENT '创建人姓名',
  "create_time" datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  "update_user_id" varchar(32) DEFAULT NULL COMMENT '修改人Id',
  "update_user_name" varchar(100) DEFAULT NULL COMMENT '修改人名称',
  "update_time" datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  "is_del" tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除，默认0(0 未删除，1已删除)',
  "lock_version" bigint(19) unsigned DEFAULT '0' COMMENT '乐观锁版本号',
  PRIMARY KEY ("id") USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户更新记录';

SET FOREIGN_KEY_CHECKS = 1;
